﻿--****************  LOOKUP_LIST
SET IDENTITY_INSERT ESL.LOOKUP_LIST ON
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (100,'Kullanıcı Tipleri','EUserType');
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (101,'Kan Grupları','EBloodGroup');
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (102,'Cinsiyet','EGender');
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (103,'Medeni Durumu','EMartialStatus');
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (104,'İletişim Tipleri','EContactType');
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (105,'Diller','ELanguages');
INSERT INTO ESL.LOOKUP_LIST (Id,Name,Explanation) VALUES (106,'Ban Tipleri','EBanType');
SET IDENTITY_INSERT ESL.LOOKUP_LIST OFF

--****************  LOOKUP_LIST_ITEM
SET IDENTITY_INSERT ESL.LOOKUP_LIST_ITEM ON
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10001,100,'Admin');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10002,100,'Moderator');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10003,100,'Supervisor');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10004,100,'Boss');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10005,100,'Worker');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10006,100,'Advertieser');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10007,100,'Guest');

INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10101,101,'A');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10102,101,'B');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10103,101,'AB');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10104,101,'0');

INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10201,102,'Erkek');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10202,102,'Kadın');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10203,102,'Bilinmeyen');

INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10301,103,'Bekar');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10302,103,'Evli');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10303,103,'Dul');

INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10401,104,'Cep Telefonu');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10402,104,'Ev Telefonu');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10403,104,'İş Telefonu');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10404,104,'EMail');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10405,104,'Çağrı Cihazı');

INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10501,105,'Türkçe');
INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10502,105,'İngilizce');

INSERT INTO ESL.LOOKUP_LIST_ITEM (Id,LookupListId,Name) VALUES (10601,106,'Uygunsuz Davranış');
SET IDENTITY_INSERT ESL.LOOKUP_LIST_ITEM OFF




--****************  LOOKUP_LIST_ITEM_LANG
SET IDENTITY_INSERT ESL.LOOKUP_LIST_ITEM_LANG ON
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000101,10001,10502,'Admin');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000201,10002,10502,'Moderator');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000301,10003,10502,'Supervisor');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000401,10004,10502,'Boss');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000501,10005,10502,'Worker');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000601,10006,10502,'Advertieser');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1000701,10007,10502,'Guest');
                                                                              			 
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1010101,10101,10502,'A');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1010201,10102,10502,'B');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1010301,10103,10502,'AB');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1010401,10104,10502,'0');
                                                                                 		 
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1020101,10201,10502,'Man');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1020201,10202,10502,'Woman');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1020301,10203,10502,'UnKnown');
                                       													 
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1030101,10301,10502,'Single');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1030201,10302,10502,'Married');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1030301,10303,10502,'Divorced');
                                                                                    	 
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1040101,10401,10502,'Mobile Phone');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1040201,10402,10502,'Home Phone');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1040301,10403,10502,'Work Phone');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1040401,10404,10502,'EMail');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1040501,10405,10502,'Caller Id');
                                                                                         
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1050101,10501,10502,'Turkish');
INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1050201,10502,10502,'English');

INSERT INTO ESL.LOOKUP_LIST_ITEM_LANG (Id,LookupListItemId,LanguageId,Name) VALUES (1060101,10601,10502,'Inconvenient Behavior');
SET IDENTITY_INSERT ESL.LOOKUP_LIST_ITEM_LANG OFF